package com.zch.house.service;

import java.sql.Date;
import java.util.List;

import com.zch.house.entity.FlatRepair;

public interface FlatRepairService {
	/**
	 * 根据条件模糊查询相应的房屋修缮信息
	 * @param sql
	 * @param params
	 * @return
	 */
	public List<FlatRepair> getAllFlatRepairByPage(String area, String estate,int unitNumber,int floor, 
			Date startDate, Date endDate,int pageIndex);
	/**
	 * 获得查询的总页码
	 * @param sql
	 * @param params
	 * @return
	 */
	public int getTotalCount(String area, String estate,int unitNumber,int floor, 
			Date startDate, Date endDate);
	/**
	 * 根据房屋修缮的唯一标识获得房屋修缮信息
	 * @param h_id
	 * @return
	 */
	public FlatRepair getFlatRepairById(int h_id);
	/**
	 * 添加房屋修缮信息
	 * @param flatRepair
	 * @return
	 */
	public boolean addFlatRepair(FlatRepair flatRepair);
	/**
	 * 根据房屋修缮的唯一标识删除房屋修缮信息
	 * @param h_id
	 * @return
	 */
	public boolean deleteFlatRepair(int h_id);
	/**
	 * 修改房屋修缮信息
	 * @param flatRepair
	 * @return
	 */
	public boolean updateFlatRepair(FlatRepair flatRepair);
}
